Overview

Row

Fastest Time, this Month!

20

Median of this Month

48

Mean of this Month

62.72

Slowest Time this Month

267

Row

Distribution of all Times

Average Times by Day of the Week

Row

Fastest Time Ever!

13

Median of all Times

52

Mean of all Times

63.49

Slowest Time Ever

469

Comparing Times

Row

All the Data!

Non-Saturdays

Saturdays

Reporting Frequencies

Row

How Often Everyone Reports

Who is not Reporting?

Row

Description

Hello!

Claire and I have been wanting to look at our puzzle times for a while now; we have been texting them to each other for over a year! She spent some time last November typing up a few months of results, but that quickly turned out to be unsustainable.

I have been working on text-mining projects at work lately, and so I figured that I would take a crack at reading in our text messages. It turns out it is pretty simple to save an iMessage chat as a pdf, and from there getting it into R is quite easy. Most messages come with a tag of who sent them, and I can infer the rest. Each day the first message always gets a date-time stamp that I use to figure out the date of the puzzles.

I try to remove some puzzle times that are in texts with the words “Eli” or “Deborah” or “Chris”, as not to erroneusly assign them. One fault of this is that we lose times where we say, “1:44! Eli kept poking me!”, but alas, what can one do.

I also remove times that are not on a Saturday and are above 5 minutes. I checked a few of these and they were all large crossword puzzle times we had sent to the group. I’m confident many other errors slipped through my grasp.

The charts took me a bit to make, and I think that they all came out well. I particuraly enjoy knowing that Wednesday is our best day and Monday and Friday our worst (ommiting the twice-as-difficult Saturday puzzle). Claire holds a pretty strong lead over the rest of us, I must say, getting 1st place nearly 50% of the times she enters a Times time. I can see that I personally have the most room left for improvement which is quite the encouragement.

Currently, updates for this should be as simple as me logging onto my laptop, saving a pdf, and rerunning a short script. I’m hoping to spend time exploring the possibility of having a script automatically do that, so our leaderboards and charts and averages could update every night, but that may be beyond my powers. Also, while this is currently just an html file, I may look into finding it a home on the internet.

May the best time puzzle,

Matthew

P.S. If you have any requests for specific data-crunches, let me know.